ALTER TABLE Region 
ADD CONSTRAINT CK_RegionID CHECK (LEN(RegionCode)= 5);